/*
This script will remove all data loaded into the 
Umbraco database via the CreateSchema.sql script.
This script should be run when planning to migrate 
data from an existing Umbraco database.
 */
DELETE cmsPropertyData
DELETE cmsPropertyType
DELETE cmsPreviewXml
DELETE cmsDataTypePreValues
DELETE cmsTab
DELETE cmsContentTypeAllowedContentType
DELETE cmsContentVersion
DELETE cmsContentXml
DELETE cmsDocument
DELETE cmsDocumentType
DELETE umbracoUser2app
DELETE umbracoUser
DELETE cmsTemplate
DELETE umbracoAppTree
DELETE cmsDataType
DELETE cmsContent
DELETE cmsContentType
DELETE cmsStylesheet
DELETE cmsMacroPropertyType
DELETE umbracoLanguage
DELETE umbracoLog
DELETE umbracoNode
DELETE umbracoApp
DELETE umbracoRelationType
DELETE cmsTaskType
DELETE umbracoUserLogins
DELETE umbracoUserType
GO